Data Visualization Final Project: Health Insurance Coverage in the United States
Grace Kong, Iris Chen & Fang Liu (Group P)
Introduction
Goals of the project
In this project, we present a state-level overview of the expansion of health insurance in the United States and its effects on health outcomes and cost outcomes, from 2008 to 2015 under President Obama’s term. One of the hallmarks of Obama’s presidency was the passage and implementation of the Affordable Care Act (ACA) to increase health insurance coverage and regulate healthcare provision to protect consumers’ rights. In addition, we are also interested in how people perceive the (ACA), as seen from articles related to the ACA from the New York Times.
Research Questions:
Trends of health insurance expansion in the United States: How has the percentage of uninsured Americans changed overall, and differentially by states, from 2008 to 2015? How has the composition of healthcare sources changed?
Health outcomes: How do the states compare in health outcomes, such as mortality rates and access to preventative and remedying treatments?
Financial outcomes: How do the states compare in financial and cost outcomes, such as the containment of out-of-pocket costs, insurance premium growth and government spending?
Perceptions of the ACA: We used API to download articles realted to ACA on New York Times from 2011-2017 and transformed them into a corpus to conduct a text analysis. How has the overall trend of public attention changed over the years, as seen by the number of articles relating to the ACA? What topics do people focus on when they discuss the ACA?
Overview of the Affordable Care Act in the United States
The Patient Protection and Affordable Care Act (ACA), also commonly known as Obamacare, was a major and wide-sweeping healthcare reform initiative enacted by Preseident Obama. The ACA was signed into law by Obama on March 23, 2010, and changes were gradually implemented over the next few years, though the majority of the provisions went into effect only on January 1, 2014.
The major goal of the ACA is to expand health insurance and healthcare access to those who otherwise did not have access, including the 45 million Americans who were uninsured before the ACA took effect. In addition, it also covers wide-ranging regulations for the protection of healthcare consumer rights. Prior to the ACA, many low-income Americans we unable to afford any health insurance, while people with disabilities and pre-existing conditions may have been denied coverage by insurerers.
The key provisions of the ACA include
Employer mandate: Employers with more than 50 employees are required to provide health insurance to full-time workers, or would otherwise face a fine
Individual mandate: Individuals must obtain “minimum essential coverage” for healthcare, and those without health insurance must pay a fine in their annual tax returns to the IRS
State and federal marketplaces: These health insurance exchanges were set-up to enable people “shopping” for insurance to make easy comparisons among the insurance plans available, thus inreasing competition in the marketplace as well.
Medicaid expansion: The ACA expands medicaid to all individuals earning less than 138% of the federal poverty level (FPL), enabled first by federal funding and . After the Supreme Court ruled this requirement as unconstitutional (thus optional) in 2012, 31 states have elected to expand medicaid, while 19 have not.
Federal subsidies to people earning between 138% and 400% of the FPL to afford monthly health insurance premiums.
Regulations preventing insurance companies from discriminating in price and provision based on people’s age, gender, or pre-existing conditions
These provisions of the ACA make health insurance accessible and affordable to people previously without coverage. In addition, people who already have health insurance would also benefit from increased choice, a cap on out-of-pocket expenses, as well as more comprehensive coverage, as insurance is now required to cover more basic treatments than before.
However, this increased coverage comes at a cost of increased premium growths for consumers, and increases in federal spending. The expansion of health insurance and healthcare coverage is projected to cost of the U.S. government up to $1.34 trillion over the next decade. It is thus no surprise that the States fall on various sides of the political spectrum when it comes to support for medicaid.
Text analysis: Media and the Affordable care act
We are also interested in how people think about Affordable care act(ACA). We want to have a look of the tweets and newspaper related to ACA. To realize this, we use API to download articles realted to ACA on New york times from 2011-2017 and transform them into corpus to do the text analysis.
Research Questions: 1) The overll trend of publuc attention, which can be shown as the number of articles related to ACA in different years. 2) What people discuss about when they discuss ACA, which can be shown as the word frequencies.
We could see that people discussed ACA a lot when obama first signed it, and the election in 2017 made it a hot topic again. And not suprisingly, peopel always talk about Trump when they talk about ACA
## Loading required package: sp## rgdal: version: 1.2-6, (SVN revision 651)
## Geospatial Data Abstraction Library extensions to R successfully loaded
## Loaded GDAL runtime: GDAL 2.1.2, released 2016/10/24
## Path to GDAL shared files: /Users/a123/Library/R/3.3/library/rgdal/gdal
## Loaded PROJ.4 runtime: Rel. 4.9.1, 04 March 2015, [PJ_VERSION: 491]
## Path to PROJ.4 shared files: /Users/a123/Library/R/3.3/library/rgdal/proj
## Linking to sp version: 1.2-4##
## Attaching package: 'plotly'## The following object is masked from 'package:ggplot2':
##
## last_plot## The following object is masked from 'package:stats':
##
## filter## The following object is masked from 'package:graphics':
##
## layout##
## Attaching package: 'plyr'## The following objects are masked from 'package:plotly':
##
## arrange, mutate, rename, summarise## The following object is masked from 'package:maps':
##
## ozone##
## Attaching package: 'dplyr'## The following objects are masked from 'package:plyr':
##
## arrange, count, desc, failwith, id, mutate, rename, summarise,
## summarize## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union##
## Attaching package: 'tidyr'## The following object is masked from 'package:magrittr':
##
## extract## Loading required package: gridExtra##
## Attaching package: 'gridExtra'## The following object is masked from 'package:dplyr':
##
## combine(1) Health Insurance Coverage
Figure 1
Access our Shiny App on Uninsured Rates in the United States from 2008-2015.
Figure 2
The following figure displays the trend in the uninsured rate between 2008 and 2015. Results are shown for the USA average (in black), as well as for every individual state (in color).
We see a clear downward trend in the uninsured rate once most of the Affordable Care Act (ACA) provisions were implemented in 2014. The overall US uninsured rate decreased from 18.2% in 2010 to 10.5% in 2015.
However, note that the disparities in uninsured rates largely continue to persist among the states, with regional patterns (using Bureau of Economic Analysis (BEA) regions). States of the Southeast and Southwest consistently had the highest uninsured rates, while states of New England consistenely had the lowest insured or highest health insurance coverage rates.
Figure 3
In the following plot, I explore the difference between Democratic and Republican states, based on the 2012 US Presidential Election results. Generally, the democratic states consistently have had largely have a lower uninsured rate than the Republican states, though both groups experienced declines in the uninsured rates in 2014. The rate of decline of uninsured rates in 2014 for many Republican states appeared to exceed that of the Democratic states, mainly because of their higher starting point.
Figure 4
This plot shows insured rates in 2015 at a glance, looking at how they differ by party (2012 winner), BEA region and income level of the states.
In terms of correlations, it appears that being a Democratic state is a strong predictor of a higher insurance rate. States in New England, the Mideast and the Great Lakes perform well in insurance rates, while states in the Southwest, Rocky Mountains and Southeast perform the poorest. As expected, high-income states have the highest insurance rates as more people would be able to afford insurance. Lower and lower-middle income states have lower coverage rates, but it is infact the lower-middle income states that have the lowest insurance rates.
Figure 5
Next, we investigate the main health insurance and coverage sources, namely employer coverage, the individual marketplace, Medicaid / Childrens’ Health Insurance Program (CHIP), and Medicare for the aged. We broke down the results by party and income level, taking a simple (unweighted) average across the states in the categories. We observe that employer coverage rates increase as income level increases, especially for Democratic states. Democratic and low income states have more people on Medicaid / CHIP than Republican and low income states.
(2) Health Outcomes and Access
Figure 6
Next, we are interested to find out how health insurance rates correlates with health outcomes. In particular, we can look at the measure of mortality amenable to healthcare intervention - the number of deaths that could have been prevented by healthcare in the year 2014. We plot avoidable mortality (2014) against insurance rates (2014) and observe a negative relationship as expected. States that have higher rates of insurance also have better health in this respect. However, we also control for income levels as low income levels would be a major predictor of poor health, as confirmed in our plot. Yet, within each income level, the negative relationship remains, and it is especially pronounced among the upper-middle income countries.
Figure 7
The following maps how the states performed in various health outcomes, namely preventable mortality, access to a usual source of care, rate of age-appropriate cancer screenings in adults, and rate of age-appropriate vaccinations in adults. A green color incidates a comparatively more favorable outcome, while a red color indicates a less favorable outcome.
We note that the Northeast (New England) states perform consistently well across all health outcomes, while the Southeast states, as well as Texes, peform consistently poorly on all except for vaccination rates. The Western and Rocky Mountains states have a low avoidable mortality rate, despite having low rates of access to usual care and of cancer screening and vaccinations. In the measure of adult vaccination rates, the trend of the South faring poorer on health is reversed, as they do comparatively well in vaccinations.
(3) Affordability and Cost Outcomes
Figure 8
Similarly, we map how the states performed in various financial and cost outcomes, such as percentage of people with high OOP costs relative to household income, premium growth rates, affordability of the marketplace plans, and increases in federal spending related to the state.
We notice that states that do better in containing OOP costs tend to do worse in containing premium and marketplace plan rates as well as federal spending. These include some states like New York, New Jersey and Ohio in the Northeast and Midwest (Great Lakes). A notable exception is Massachussets, which performs well across the financial measures, possibly because of the headstart it got with “Romney-care”, which actually served as a model for Obamacare.
Summary of States’ Performance
The following data table presents the rankings of the states on the following insurance coverage, health and affordability outcomes, providing a summary of the states’ performance:
Percentage of population insured
Deaths preventable by healthcare intervention (per 100,000 people)
Proportion of adults with access to a usual source of care
Proportion of people with high out-of-pocket costs (relative to household income)
Annual rate of health insurance premium growth from 2010 to 2015
A rank of 1 always indicates the more favorable outcome (i.e. higher insurance and treatment access rate, lower preventable mortality, OOP costs and premium growth)
Figure 9
(4) Perceptions of ACA (Text Analysis)
## Loading required package: NLP##
## Attaching package: 'NLP'## The following object is masked from 'package:ggplot2':
##
## annotate##
## Attaching package: 'lubridate'## The following object is masked from 'package:plyr':
##
## here## The following object is masked from 'package:base':
##
## date## quanteda version 0.9.9.24## Using 3 of 4 cores for parallel computing##
## Attaching package: 'quanteda'## The following objects are masked from 'package:tm':
##
## as.DocumentTermMatrix, stopwords## The following object is masked from 'package:NLP':
##
## ngrams## The following object is masked from 'package:readr':
##
## tokenize## The following object is masked from 'package:utils':
##
## View## The following object is masked from 'package:base':
##
## sample## Loading required package: qdapDictionaries## Loading required package: qdapRegex##
## Attaching package: 'qdapRegex'## The following objects are masked from 'package:dplyr':
##
## escape, explain## The following object is masked from 'package:ggplot2':
##
## %+%## Loading required package: qdapTools##
## Attaching package: 'qdapTools'## The following object is masked from 'package:dplyr':
##
## id## The following object is masked from 'package:plyr':
##
## id##
## Attaching package: 'qdap'## The following objects are masked from 'package:quanteda':
##
## as.DocumentTermMatrix, as.wfm, ngrams, weight## The following object is masked from 'package:stringr':
##
## %>%## The following objects are masked from 'package:tm':
##
## as.DocumentTermMatrix, as.TermDocumentMatrix## The following object is masked from 'package:NLP':
##
## ngrams## The following object is masked from 'package:tidyr':
##
## %>%## The following object is masked from 'package:dplyr':
##
## %>%## The following object is masked from 'package:magrittr':
##
## %>%## The following object is masked from 'package:plotly':
##
## %>%## The following object is masked from 'package:DT':
##
## %>%## The following object is masked from 'package:leaflet':
##
## %>%## The following object is masked from 'package:base':
##
## FilterFigure 10
We could see that people discussed ACA a lot when Obama first signed it, and the election in 2017 made it a hot topic again. And not suprisingly, people always talk about Trump when they talk about ACA.
## Creating a dfm from a corpus ...## ... lowercasing## ... tokenizing## ... found 1,000 documents, 22,386 features## ...## removed 169 features, from 174 supplied (glob) feature types## ... stemming features (English)## , trimmed 7834 feature variants## ... created a 1,000 x 14,383 sparse dfm
## ... complete.
## Elapsed time: 2.14 seconds.## Document-feature matrix of: 1,000 documents, 5 features (88.9% sparse).## [1] "i" "me" "my" "myself" "we"
## [6] "our" "ours" "ourselves" "you" "your"
## [11] "yours" "yourself" "yourselves" "he" "him"
## [16] "his" "himself" "she" "her" "hers"Figure 11
Figure 12
Wordcloud by Year
